Title: Project Report Writing

Project Report should have following components:

• Introduction: This section should be able to convey what is the project about, for what purpose the project is done, who are the users of project, what are their requirements
.
• Duration of project. Start Date: End Date
• Schedule specifying when what will be done
• Tools used to Develop Project

Objective of doing project

• User Requirements
• Project Design
• Testing
• User Acceptance testing
• Conclusion

Title: Billing System

• This application is developed to facilitate shopkeepers and salesperson in creating bills of products they sell. The bill will contain information about the products purchased by customer, total of each product, total, tax-rate and total after tax deducation. Shopkeeper has to first enter data about each product in the database using User Interface. At the time of billing, bar code of each product purchased by customer and quantity are inserted, grand total is automatically calculated and total after tax deducation.
• This application will save time of shopkeer and reduces in making calculation mistakes.
• This application is developed using JAVA and MySQL

Objective:

• To make error less bill
• Save time of both customer and salesperson

Requirement collection

• Communication with salesperson, sales managers is done and their requirements are written down
• On the basis of barcode, name, price of product should be displayed, and as quantity is given, total amount for a product should be calculated
• Any number of products should be possible to insert, as how many products customers will puchase is not known
• Tax amount should be calculated automatically and total after tax deducation should be displayed
• Bill should be printed in three inch wide paper
• Bill should appear as Bill number is provided
• Bill information should be known by date

Design

• Objects found after requirements collection are:
• Product, tax, Bill
• Database Tables to be designed: table for product, to store bill information
• Attributes of product: barcode_number, name, unit_price; Attributes of Bill_table: billno, barcode_number, productname,quantity,unit_price,total,bill_date
• Form to insert product information, form to insert data at the billing time, bill, search form

Testing

• Data in different formants are inserted to see if things work or not, string to be given for numbers; data properly stored in database or not, form are easy to inserting data or not

Conclusion

This project is developed to help shopkeeper to make error free bill easily. This project is developed using JAVA and MySQL. This app is advantageous for all the shops.